Excel VBA: for Non-Programmers (Programming in Everyday Language) by Poleg Maayan

Excel VBA: for Non-Programmers (Programming in Everyday Language) by Poleg Maayan

Author:Poleg, Maayan [Poleg, Maayan]
Language: eng
Format: azw3
Published: 2014-04-13T16:00:00+00:00


· The keyboard shortcut ctrl+shift+ right arrow or left arrow will select the data from the cursor location to the last cell in the column (before the nearest empty cell), from the right or from the left, respectively:

Range(ActiveCell, ActiveCell.End(xlToRight)).Select

· The keyboard shortcut ctrl+asterisk (*) will select the data table.

It is customary to use the asterisk (*) key from the numeric section of the keyboard, but if you choose to use the asterisk above the number 8 from the upper row of numbers in the alpha-numeric section of the keyboard, press on the Shift key as well (ctrl+shift+8):

ActiveCell.CurrentRegion.Select



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.